﻿
IF EXISTS(SELECT * FROM sys.objects WHERE [type]='U' AND [name]='tmp_FloatDataFact') DROP TABLE [tmp_FloatDataFact];

CREATE TABLE [dbo].[tmp_FloatDataFact]
(
	[Time] BIGINT NOT NULL , 
    [TagId] BIGINT NOT NULL, 
    [Value] FLOAT NULL, 
    [IsNan] BIT NOT NULL, 
    [IsInfinity] BIT NOT NULL, 
    PRIMARY KEY ([Time], [TagId]), 
)

